from django.db import models

# Create your models here.

class Student(models.Model):
    SEX_CHOICES = ((0, '女'), (1, '男'))
    name = models.CharField(max_length=20,verbose_name="姓名")
    age = models.IntegerField(null=True,blank=True,verbose_name="年龄")
    sex = models.IntegerField(null=True,blank=True,verbose_name="性别",choices=SEX_CHOICES)
    create_time = models.DateTimeField(auto_now_add=True,verbose_name="创建时间")
    update_time = models.DateTimeField(auto_now=True,verbose_name="修改时间")

    is_delete = models.BooleanField(default=False,verbose_name="逻辑删除")

    classes = models.ForeignKey("Classes",on_delete=models.SET_NULL,null=True)

    class Meta:
        db_table = 'student'
    # 重构删除方法  实际修改状态
    def delete(self,using=None,keep_parents=False):
        self.is_delete = True
        self.save()


class Classes(models.Model):
    name = models.CharField(max_length=20,verbose_name="班级名")
    slogan = models.TextField(null=True,blank=True,verbose_name="口号")
    create_time = models.DateTimeField(auto_now_add=True,verbose_name="创建时间")
    update_time = models.DateTimeField(auto_now=True,verbose_name="修改时间")

    is_delete = models.BooleanField(default=False,verbose_name="逻辑删除")

    class Meta:
        db_table = 'classes'

    # 返回班级名称
    def __str__(self):
        return self.name


